| SaPrintCheckWork |
| Logical Entity Name | SaPrintCheckWork |
| Default Table Name | SaPrintCheckWork |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| SaPrintCheckWork Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SaPrintCheckWorkID |
int | NO | ||
| BatchId | varchar(32) | NO | ||
| EFT | varchar(5) | YES | ||
| CheckNumber | varchar(20) | YES | ||
| PrintCheckNumber | varchar(7) | YES | ||
| CheckDate | datetime | YES | ||
| CheckComment | nvarchar(75) | YES | ||
| Bank | varchar(65) | YES | ||
| BankAccount | varchar(65) | YES | ||
| CheckAmount | money | YES | ||
| PayeeName | nvarchar(376) | YES | ||
| PayeeAddress1 | varchar(255) | YES | ||
| PayeeAddress2 | varchar(50) | YES | ||
| PayeeCity | varchar(50) | YES | ||
| PayeeState | varchar(50) | YES | ||
| PayeeZip | varchar(20) | YES | ||
| RefComment | nvarchar(75) | YES | ||
| StudentName | varchar(376) | NO | ||
| StudentIdentifier | varchar(60) | YES | ||
| FundSourceCode | varchar(max) | YES | ||
| FundSourceName | varchar(max) | YES | ||
| AwardYear | varchar(max) | YES | ||
| PayeeInfo | varchar(300) | YES | ||
| AddressType | varchar(1) | YES | ||
| CampusName | varchar(120) | YES | ||
| FaLoanID | varchar(100) | YES | ||
| CampusCode | varchar(8) | YES | ||
| FaRefundID | int | YES | ||
| BankAddress | varchar(255) | YES | ||
| BankCity | varchar(25) | YES | ||
| BankState | varchar(2) | YES | ||
| BankZipCode | varchar(10) | YES | ||
| RoutingNumber | varchar(9) | YES | ||
| FractionalNumber | varchar(15) | YES | ||
| RefNoPrintOn | varchar(1) | YES | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| UserId | int | NO | ||
| ts | timestamp | NO | ||
| SyStudentID | int | YES |
| SaPrintCheckWork Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK__SaPrintC__7F55D124C7AB2680 | PrimaryKey | SaPrintCheckWorkID |
| SaPrintCheckWork Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SaPrintCheckWork Check Constraints |
| Check Constraint Name | CheckConstraint |
| SaPrintCheckWork Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group | PRIMARY |
| SaPrintCheckWork Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.SaPrintCheckWork |
NO | |||
| Physical (Microsoft SQL Server) dbo.SaPrintCheckWork |
NO |
| SaPrintCheckWork Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Physical (Microsoft SQL Server) | Main Model |
| SaPrintCheckWork Data Movement Rules |
| Name | Type | Rule Text/Value |